www.loanperformer.com

Table of Contents (Online Help)

Import Loan Repayments

If you've been using another financial software product, and you'd like to import loan repayments information from that product into Loan Performer, you can do so if the product allows you to export to a spreadsheet, dBase or text file. Loan Repayments can be imported from three file formats i.e. dBase, Microsoft Excel or Tab delimited text files. Each of these files has a standard file format on how data should be arranged.

These loan repayments templates can be downloaded from www.loanperformer.com or got from the Loan Performer working folder under the import file folder, e.g., "C:\LPF81204\External Files\Import" and it looks like the one below:

• Loan Number: This has to be an existing loan number in the Loan Performer database. Loan has to have been disbursed and not fully repaid.
• Repayment Date: Note that this date should be on or after the disbursement date and after any other repayment.
• Mode: Disbursement mode (1=Cash, 2=cheque, 3=transfer from savings).
• Recalculate: This is a character field and if blank assumes no 1. Recalculate Interest: in case of declining balance, you may want to calculate interest: 1=not recalculate interest,  1=recalculate interest.
• GL. Account: General Ledger cash or bank account. This is the Loan Performer GL A/C for the account that you use for depositing your cheques or cash. You will have to fill this in, even if you have no repayments by cheque or even if you don’t use Loan Performer for your accounting. The GL account should be an existing account.
• Cleared: This field indicates whether - in case of a disbursement by cheque - the cheque is cleared or not. It should either be empty, or have a "Y" or "N" value.
• Clearing date: If the cheque is cleared then enter the clearing date. The date should be on or after the repayment date. Empty for non cheque payments.
• Member No.: This field is only needed if you have tracking of group loans enabled (see Configuration/Loans Part 1). The field stands for the member number in the group.  The number should exist as a member number in the group.

How to Import Loans Repayments

To import loan repayments you go to Loans\Loan Importations\Import Loan Repayments and a screen like the one below shows up:

• Files of type: Specify the import file type in the files of type: box, e.g., "Microsoft Excel File".
• Import file: Specify the filename and full path to the file that should be imported in the Import file: box. Alternatively click on the Choose command button to select the file from a specified location.
• Error File: Specify the name of the file to which errors will be written (usually Repaymen.txt).
• Import file format: This scroll window lists the various fields of the file to be imported and their properties.
• Imported Files: This scroll window lists all previously imported files.
• Import: Click on the Import command button to import the set repayments transactions.
• Reset: When you click on this command button, the imported file log will be cleared
• Repayment priorities modifiable: Select the applicable radio button if you want the repayment priorities to be modified or not.
• View: This button opens the selected import file within its corresponding application
• Cancel: Closes the Import Loan Repayments dialog.

Note that this importation does not import repayments made by savings transfer.

Related Topics

Contact LPF live support for more information
This service requires an Internet connection.